EMT Practice Test

1. Question Content...

---

Question1: What are two characteristics of data rules?

Question2: To import metadata into Information Analyzer, a user requires which Information Server role as a minimum?

Question3: The DSN for the Information Analyzer database needs to be created on which tier?

Question4: Which two statements are relevant to key analysis in Information Analyzer?

Question5: You are analyzing a historical data source with 500 million records with approximately 15 million added per year.
You wish to analyze only records from the year 2000. The table contains a numeric field called YearAdded.
What steps will allow you to minimize the data analyzed?

Question6: You need to check multiple columns for duplicates. How does changing the column sequence in Run Duplicate Analysis affect the duplicate check analysis results?

Question7: What are the three domain analysis methods?

Question8: A customer table contains a country code column representing the customer's country. There is a corresponding lookup table that captures which country code represents each country (100=Germany,
101=France. 102=ltaly, and so on).
Which rule logic would address a requirement to find all French customers that have a phone number made up of ten digits?

Question9: You are configuring security for a user who will be testing Information Analyzer rules on an ad hoc basis.
What steps are necessary to ensure the user can test the rules?

Question10: A company is starting an Information Analysis project to assess the data quality of Key Performance Indicators (KPIs). They also want to setup on-going monitoring of the data quality and have no tolerance for error.
Which two statements are true when considering what data to analyze?

Question11: You have been tasked with documenting all fields that contain personal information while performing profiling activities.
Which method would you use to accomplish this?

Question12: Which two steps are necessary to set up data rule monitoring?

Question13: At which levels can Information Analyzer analysis settings be set?

Question14: Which type of analysis provides the benefit of monitoring your data over time so that you can determine whether the content and structure of your data has changed?

Question15: While reviewing results of a data rule test, you find a logic error. Which option will allow you to troubleshoot this error?

Question16: Which statement about published data rules is correct?

Question17: You are implementing a rule that evaluates the valid values for an Indicator field. What steps are necessary to tolerate a 1 % error rate in the executed rule?

Question18: A new business group, working in a separate and distinct Information Analyzer environment, is starting to assess their data quality, but wishes to reuse existing data quality validation to jumpstart their effort.
Which method supports delivering the data rule definitions to this new environment?

Question19: Which two steps are necessary to display exceptions in the Data Quality Console?

Question20: Which option could you use to limit which records in a table are available for Column Analysis?

Question21: Where can the Confidence Benchmark be set?

Question22: Which statement identifies one of the actions you need to perform before you can access the DataStage Director?

Question23: You are analyzing a known table with a five column primary key. You wish to confirm its uniqueness with minimal processing time.
Which steps should you take?

Question24: What column analysis process will infer a data class for each column in your data making it easier to compare domains of data?

Question25: Given that a rule set contains two data rules that use the same variables, which statement is true?

Question26: When working with Information Analyzer reports, which two functions require use of the reporting functionality in the Information Server Web Console?

Question27: The logic of a data rule has changed, producing unexpected results. What steps do you take to identify who updated the logic and when?

Question28: You need to capture the results of a data rules execution so it can be used in subsequent data rules.
Which approach will work?

Question29: It is desired to create a data rule to determine how many rows in the master data catalog have a primary shipping location that is not found in the location_number column in the "Location" table.
What is the proper rule definition logic to achieve this requirement?

Question30: Which of the following will allow you to run a data rule without using the Information Analyzer graphical user interface?

Question31: You suspect that data in a table contains inconsistent structure/formatting. Which Information Analyzer Column Analysis screen would be used to determine this?

Question32: Which two components must you identify when building a data connection in Information Analyzer?

Question33: What are three of the analytical functions used in column analysis?

Question34: Which two can be used to identify exception descriptors of interest in the Data Quality Console?